CREATE PROCEDURE [dbo].[authors_update]
    @authorId int,
    @lastName nvarchar(256),
    @firstName nvarchar(256),
    @middleName nvarchar(256)
AS
UPDATE [dbo].[Authors] SET [dbo].[Authors].[LastName] = @lastName,
    [dbo].[Authors].[FirstName] = @firstName, 
    [dbo].[Authors].[MiddleName] = @middleName
WHERE
    [dbo].[Authors].[AuthorId]=@authorId

RETURN 0
